import json

from flask import Blueprint, request, jsonify

from db import db1

bp_course = Blueprint("course", __name__)


@bp_course.route('/courseM', methods=['POST', 'GET', 'PUT', 'DELETE'])
def couponM():
    # 添加
    if request.method == "POST":
        # 获取用户输入
        data = request.data
        if data:
            data = json.loads(data)
        else:
            data = request.form
        # 构造sql语句
        sql = "insert into coupon values(0,'%s',%d,'%s','%s')" % (
            data['name'], int(data['total']), data['stime'], data['etime'])
        # pymysql
        db1.insert(sql)
        # 返回结果
        return 'ok'
    elif request.method == 'GET':
        id = request.args.get('id')
        sql = "select * from coupon where id=%d" % (int(id))
        res = db1.find(sql)
        return jsonify({'code': 200, 'coupon': res})
    elif request.method == 'PUT':
        # 获取用户输入
        data = request.data
        if data:
            data = json.loads(data)
        else:
            data = request.form
        sql = "update coupon set name='%s',total=%d,startime='%s',endtime='%s' where id=%d" % (
            data['name'], int(data['total']), data['stime'], data['etime'], int(data['id']))
        db1.insert(sql)
        return jsonify({'code': 200})
    elif request.method == 'DELETE':
        id = request.args.get('id')
        sql = "delete from coupon where id=%d" % (int(id))
        db1.insert(sql)
        return jsonify({'code': 200})
